﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using NENAData.Factory;
using NENAData.LINQ;

namespace NENAData
{
    public class NENACommittee
    {
        private static MembershipDataContext GetSQLTransaction()
        {
            var x = new SQLMembership();
            return x.GetMembershipDB();
        }

        public Members_Committee GetMember(int intMemberID)
        {

            MembershipDataContext db = GetSQLTransaction();

            var listAffilates = (from m in db.Members_Committees
                                 where m.ID == intMemberID
                                 select m).Single();

            return listAffilates;
        }
    }
}
